﻿
    using System;
    using System.Data;
    using System.Data.SqlClient;
    using System.Collections;
    using System.Collections.Generic;
    using FShop.DAL;

namespace FShop.BAL{

    ///<summary>
    ///The Class Provides methods for object operations. 
    ///</summary>
    ///<remarks>
    ///Changes to this file may cause incorrect behavior and will be lost if  the code is regenerated.
    ///Update the <see cref="Parameter_BAL"/> class if you need to add or change some functionality
    ///</remarks>
    public class Parameter_BAL  {

        #region Public Methods
		public static List<Parameter> GetList_Parameter()
		{
		   Parameter_DAL obj = new Parameter_DAL();
		   return obj.GetList_Parameter();
		}

		public static DataTable Get_ParameterAsPaging(int pageIndex,int pageSize,string sSortColumn,string sFields,string sWhere,string sGroupBy)
		{
		   Parameter_DAL obj = new Parameter_DAL();
		   if (string.IsNullOrEmpty(sSortColumn)) sSortColumn = "";
		   if (string.IsNullOrEmpty(sWhere)) sWhere = "";
		   if (string.IsNullOrEmpty(sGroupBy)) sGroupBy = "";
		   if (string.IsNullOrEmpty(sFields)) sFields = "";
		   return obj.Get_ParameterAsPaging( pageIndex, pageSize, sSortColumn, sFields, sWhere, sGroupBy);
		}

		public static DataTable Get_ParameterAsTable(string whereSql,string orderBy)
		{
		   Parameter_DAL obj = new Parameter_DAL();
		   if (string.IsNullOrEmpty(orderBy)) orderBy = "";
		   if (string.IsNullOrEmpty(whereSql)) whereSql = "";
		   return obj.Get_ParameterAsTable(whereSql,orderBy);
		}

		public static Parameter Get_Parameter_ByID(System.String Para_Name)
		{
		   Parameter_DAL obj = new Parameter_DAL();
		   return obj.Get_Parameter_ByID(Para_Name);
		}

		public static void Delete_Parameter(Parameter temp)
		{
		   Parameter_DAL obj = new Parameter_DAL();
		   obj.Delete_Parameter( temp);
		}

		public static void Delete_Parameter_Where(string whereSql)
		{
		   Parameter_DAL obj = new Parameter_DAL();
		   if (string.IsNullOrEmpty(whereSql)) whereSql = "";
		   obj.Delete_Parameter_Where( whereSql );
		}

		public static void Insert_Parameter(Parameter temp)
		{
		   Parameter_DAL obj = new Parameter_DAL();
		   obj.Insert_Parameter(temp);
		}

		public static void Update_Parameter(Parameter temp)
		{
		   Parameter_DAL obj = new Parameter_DAL();
		   obj.Update_Parameter(temp);
		}

#endregion
 }
}
